package com.crm.model.entity.customerManager;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CustomerProductDetailMemberCardRawDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CustomerProductDetailMemberCardRawDataExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andMembershipCardRawDataIdIsNull() {
            addCriterion("membership_card_raw_data_id is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdIsNotNull() {
            addCriterion("membership_card_raw_data_id is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdEqualTo(String value) {
            addCriterion("membership_card_raw_data_id =", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdNotEqualTo(String value) {
            addCriterion("membership_card_raw_data_id <>", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdGreaterThan(String value) {
            addCriterion("membership_card_raw_data_id >", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_raw_data_id >=", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdLessThan(String value) {
            addCriterion("membership_card_raw_data_id <", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdLessThanOrEqualTo(String value) {
            addCriterion("membership_card_raw_data_id <=", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdLike(String value) {
            addCriterion("membership_card_raw_data_id like", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdNotLike(String value) {
            addCriterion("membership_card_raw_data_id not like", value, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdIn(List<String> values) {
            addCriterion("membership_card_raw_data_id in", values, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdNotIn(List<String> values) {
            addCriterion("membership_card_raw_data_id not in", values, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdBetween(String value1, String value2) {
            addCriterion("membership_card_raw_data_id between", value1, value2, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andMembershipCardRawDataIdNotBetween(String value1, String value2) {
            addCriterion("membership_card_raw_data_id not between", value1, value2, "membershipCardRawDataId");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmIsNull() {
            addCriterion("card_create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmIsNotNull() {
            addCriterion("card_create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmEqualTo(String value) {
            addCriterion("card_create_tm =", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmNotEqualTo(String value) {
            addCriterion("card_create_tm <>", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmGreaterThan(String value) {
            addCriterion("card_create_tm >", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmGreaterThanOrEqualTo(String value) {
            addCriterion("card_create_tm >=", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmLessThan(String value) {
            addCriterion("card_create_tm <", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmLessThanOrEqualTo(String value) {
            addCriterion("card_create_tm <=", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmLike(String value) {
            addCriterion("card_create_tm like", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmNotLike(String value) {
            addCriterion("card_create_tm not like", value, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmIn(List<String> values) {
            addCriterion("card_create_tm in", values, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmNotIn(List<String> values) {
            addCriterion("card_create_tm not in", values, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmBetween(String value1, String value2) {
            addCriterion("card_create_tm between", value1, value2, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCardCreateTmNotBetween(String value1, String value2) {
            addCriterion("card_create_tm not between", value1, value2, "cardCreateTm");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNull() {
            addCriterion("company is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNotNull() {
            addCriterion("company is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyEqualTo(String value) {
            addCriterion("company =", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotEqualTo(String value) {
            addCriterion("company <>", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyGreaterThan(String value) {
            addCriterion("company >", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("company >=", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLessThan(String value) {
            addCriterion("company <", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLessThanOrEqualTo(String value) {
            addCriterion("company <=", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLike(String value) {
            addCriterion("company like", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotLike(String value) {
            addCriterion("company not like", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyIn(List<String> values) {
            addCriterion("company in", values, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotIn(List<String> values) {
            addCriterion("company not in", values, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyBetween(String value1, String value2) {
            addCriterion("company between", value1, value2, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotBetween(String value1, String value2) {
            addCriterion("company not between", value1, value2, "company");
            return (Criteria) this;
        }

        public Criteria andSalesmanIsNull() {
            addCriterion("salesman is null");
            return (Criteria) this;
        }

        public Criteria andSalesmanIsNotNull() {
            addCriterion("salesman is not null");
            return (Criteria) this;
        }

        public Criteria andSalesmanEqualTo(String value) {
            addCriterion("salesman =", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanNotEqualTo(String value) {
            addCriterion("salesman <>", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanGreaterThan(String value) {
            addCriterion("salesman >", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanGreaterThanOrEqualTo(String value) {
            addCriterion("salesman >=", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanLessThan(String value) {
            addCriterion("salesman <", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanLessThanOrEqualTo(String value) {
            addCriterion("salesman <=", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanLike(String value) {
            addCriterion("salesman like", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanNotLike(String value) {
            addCriterion("salesman not like", value, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanIn(List<String> values) {
            addCriterion("salesman in", values, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanNotIn(List<String> values) {
            addCriterion("salesman not in", values, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanBetween(String value1, String value2) {
            addCriterion("salesman between", value1, value2, "salesman");
            return (Criteria) this;
        }

        public Criteria andSalesmanNotBetween(String value1, String value2) {
            addCriterion("salesman not between", value1, value2, "salesman");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIsNull() {
            addCriterion("son_owner is null");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIsNotNull() {
            addCriterion("son_owner is not null");
            return (Criteria) this;
        }

        public Criteria andSonOwnerEqualTo(String value) {
            addCriterion("son_owner =", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotEqualTo(String value) {
            addCriterion("son_owner <>", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerGreaterThan(String value) {
            addCriterion("son_owner >", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("son_owner >=", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLessThan(String value) {
            addCriterion("son_owner <", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLessThanOrEqualTo(String value) {
            addCriterion("son_owner <=", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLike(String value) {
            addCriterion("son_owner like", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotLike(String value) {
            addCriterion("son_owner not like", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIn(List<String> values) {
            addCriterion("son_owner in", values, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotIn(List<String> values) {
            addCriterion("son_owner not in", values, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerBetween(String value1, String value2) {
            addCriterion("son_owner between", value1, value2, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotBetween(String value1, String value2) {
            addCriterion("son_owner not between", value1, value2, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andCardNumberIsNull() {
            addCriterion("card_number is null");
            return (Criteria) this;
        }

        public Criteria andCardNumberIsNotNull() {
            addCriterion("card_number is not null");
            return (Criteria) this;
        }

        public Criteria andCardNumberEqualTo(String value) {
            addCriterion("card_number =", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotEqualTo(String value) {
            addCriterion("card_number <>", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberGreaterThan(String value) {
            addCriterion("card_number >", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberGreaterThanOrEqualTo(String value) {
            addCriterion("card_number >=", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberLessThan(String value) {
            addCriterion("card_number <", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberLessThanOrEqualTo(String value) {
            addCriterion("card_number <=", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberLike(String value) {
            addCriterion("card_number like", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotLike(String value) {
            addCriterion("card_number not like", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberIn(List<String> values) {
            addCriterion("card_number in", values, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotIn(List<String> values) {
            addCriterion("card_number not in", values, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberBetween(String value1, String value2) {
            addCriterion("card_number between", value1, value2, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotBetween(String value1, String value2) {
            addCriterion("card_number not between", value1, value2, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNull() {
            addCriterion("start_date is null");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNotNull() {
            addCriterion("start_date is not null");
            return (Criteria) this;
        }

        public Criteria andStartDateEqualTo(String value) {
            addCriterion("start_date =", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotEqualTo(String value) {
            addCriterion("start_date <>", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThan(String value) {
            addCriterion("start_date >", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThanOrEqualTo(String value) {
            addCriterion("start_date >=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThan(String value) {
            addCriterion("start_date <", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThanOrEqualTo(String value) {
            addCriterion("start_date <=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLike(String value) {
            addCriterion("start_date like", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotLike(String value) {
            addCriterion("start_date not like", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateIn(List<String> values) {
            addCriterion("start_date in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotIn(List<String> values) {
            addCriterion("start_date not in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateBetween(String value1, String value2) {
            addCriterion("start_date between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotBetween(String value1, String value2) {
            addCriterion("start_date not between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNull() {
            addCriterion("end_date is null");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNotNull() {
            addCriterion("end_date is not null");
            return (Criteria) this;
        }

        public Criteria andEndDateEqualTo(String value) {
            addCriterion("end_date =", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotEqualTo(String value) {
            addCriterion("end_date <>", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThan(String value) {
            addCriterion("end_date >", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThanOrEqualTo(String value) {
            addCriterion("end_date >=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThan(String value) {
            addCriterion("end_date <", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThanOrEqualTo(String value) {
            addCriterion("end_date <=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLike(String value) {
            addCriterion("end_date like", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotLike(String value) {
            addCriterion("end_date not like", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIn(List<String> values) {
            addCriterion("end_date in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotIn(List<String> values) {
            addCriterion("end_date not in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateBetween(String value1, String value2) {
            addCriterion("end_date between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotBetween(String value1, String value2) {
            addCriterion("end_date not between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyIsNull() {
            addCriterion("amount_money is null");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyIsNotNull() {
            addCriterion("amount_money is not null");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyEqualTo(String value) {
            addCriterion("amount_money =", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyNotEqualTo(String value) {
            addCriterion("amount_money <>", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyGreaterThan(String value) {
            addCriterion("amount_money >", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyGreaterThanOrEqualTo(String value) {
            addCriterion("amount_money >=", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyLessThan(String value) {
            addCriterion("amount_money <", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyLessThanOrEqualTo(String value) {
            addCriterion("amount_money <=", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyLike(String value) {
            addCriterion("amount_money like", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyNotLike(String value) {
            addCriterion("amount_money not like", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyIn(List<String> values) {
            addCriterion("amount_money in", values, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyNotIn(List<String> values) {
            addCriterion("amount_money not in", values, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyBetween(String value1, String value2) {
            addCriterion("amount_money between", value1, value2, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyNotBetween(String value1, String value2) {
            addCriterion("amount_money not between", value1, value2, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNull() {
            addCriterion("phone_number is null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNotNull() {
            addCriterion("phone_number is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberEqualTo(String value) {
            addCriterion("phone_number =", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotEqualTo(String value) {
            addCriterion("phone_number <>", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThan(String value) {
            addCriterion("phone_number >", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThanOrEqualTo(String value) {
            addCriterion("phone_number >=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThan(String value) {
            addCriterion("phone_number <", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThanOrEqualTo(String value) {
            addCriterion("phone_number <=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLike(String value) {
            addCriterion("phone_number like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotLike(String value) {
            addCriterion("phone_number not like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIn(List<String> values) {
            addCriterion("phone_number in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotIn(List<String> values) {
            addCriterion("phone_number not in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberBetween(String value1, String value2) {
            addCriterion("phone_number between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotBetween(String value1, String value2) {
            addCriterion("phone_number not between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberIsNull() {
            addCriterion("train_card_number is null");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberIsNotNull() {
            addCriterion("train_card_number is not null");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberEqualTo(String value) {
            addCriterion("train_card_number =", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberNotEqualTo(String value) {
            addCriterion("train_card_number <>", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberGreaterThan(String value) {
            addCriterion("train_card_number >", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberGreaterThanOrEqualTo(String value) {
            addCriterion("train_card_number >=", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberLessThan(String value) {
            addCriterion("train_card_number <", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberLessThanOrEqualTo(String value) {
            addCriterion("train_card_number <=", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberLike(String value) {
            addCriterion("train_card_number like", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberNotLike(String value) {
            addCriterion("train_card_number not like", value, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberIn(List<String> values) {
            addCriterion("train_card_number in", values, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberNotIn(List<String> values) {
            addCriterion("train_card_number not in", values, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberBetween(String value1, String value2) {
            addCriterion("train_card_number between", value1, value2, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTrainCardNumberNotBetween(String value1, String value2) {
            addCriterion("train_card_number not between", value1, value2, "trainCardNumber");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNull() {
            addCriterion("payment_time is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNotNull() {
            addCriterion("payment_time is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualTo(String value) {
            addCriterion("payment_time =", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualTo(String value) {
            addCriterion("payment_time <>", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThan(String value) {
            addCriterion("payment_time >", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualTo(String value) {
            addCriterion("payment_time >=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThan(String value) {
            addCriterion("payment_time <", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualTo(String value) {
            addCriterion("payment_time <=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLike(String value) {
            addCriterion("payment_time like", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotLike(String value) {
            addCriterion("payment_time not like", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIn(List<String> values) {
            addCriterion("payment_time in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotIn(List<String> values) {
            addCriterion("payment_time not in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeBetween(String value1, String value2) {
            addCriterion("payment_time between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotBetween(String value1, String value2) {
            addCriterion("payment_time not between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andCardDetailIsNull() {
            addCriterion("card_detail is null");
            return (Criteria) this;
        }

        public Criteria andCardDetailIsNotNull() {
            addCriterion("card_detail is not null");
            return (Criteria) this;
        }

        public Criteria andCardDetailEqualTo(String value) {
            addCriterion("card_detail =", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailNotEqualTo(String value) {
            addCriterion("card_detail <>", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailGreaterThan(String value) {
            addCriterion("card_detail >", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailGreaterThanOrEqualTo(String value) {
            addCriterion("card_detail >=", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailLessThan(String value) {
            addCriterion("card_detail <", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailLessThanOrEqualTo(String value) {
            addCriterion("card_detail <=", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailLike(String value) {
            addCriterion("card_detail like", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailNotLike(String value) {
            addCriterion("card_detail not like", value, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailIn(List<String> values) {
            addCriterion("card_detail in", values, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailNotIn(List<String> values) {
            addCriterion("card_detail not in", values, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailBetween(String value1, String value2) {
            addCriterion("card_detail between", value1, value2, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andCardDetailNotBetween(String value1, String value2) {
            addCriterion("card_detail not between", value1, value2, "cardDetail");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordIsNull() {
            addCriterion("offline_course_attendance_record is null");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordIsNotNull() {
            addCriterion("offline_course_attendance_record is not null");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordEqualTo(String value) {
            addCriterion("offline_course_attendance_record =", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordNotEqualTo(String value) {
            addCriterion("offline_course_attendance_record <>", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordGreaterThan(String value) {
            addCriterion("offline_course_attendance_record >", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordGreaterThanOrEqualTo(String value) {
            addCriterion("offline_course_attendance_record >=", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordLessThan(String value) {
            addCriterion("offline_course_attendance_record <", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordLessThanOrEqualTo(String value) {
            addCriterion("offline_course_attendance_record <=", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordLike(String value) {
            addCriterion("offline_course_attendance_record like", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordNotLike(String value) {
            addCriterion("offline_course_attendance_record not like", value, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordIn(List<String> values) {
            addCriterion("offline_course_attendance_record in", values, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordNotIn(List<String> values) {
            addCriterion("offline_course_attendance_record not in", values, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordBetween(String value1, String value2) {
            addCriterion("offline_course_attendance_record between", value1, value2, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCourseAttendanceRecordNotBetween(String value1, String value2) {
            addCriterion("offline_course_attendance_record not between", value1, value2, "offlineCourseAttendanceRecord");
            return (Criteria) this;
        }

        public Criteria andCourseNameIsNull() {
            addCriterion("course_name is null");
            return (Criteria) this;
        }

        public Criteria andCourseNameIsNotNull() {
            addCriterion("course_name is not null");
            return (Criteria) this;
        }

        public Criteria andCourseNameEqualTo(String value) {
            addCriterion("course_name =", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameNotEqualTo(String value) {
            addCriterion("course_name <>", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameGreaterThan(String value) {
            addCriterion("course_name >", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameGreaterThanOrEqualTo(String value) {
            addCriterion("course_name >=", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameLessThan(String value) {
            addCriterion("course_name <", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameLessThanOrEqualTo(String value) {
            addCriterion("course_name <=", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameLike(String value) {
            addCriterion("course_name like", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameNotLike(String value) {
            addCriterion("course_name not like", value, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameIn(List<String> values) {
            addCriterion("course_name in", values, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameNotIn(List<String> values) {
            addCriterion("course_name not in", values, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameBetween(String value1, String value2) {
            addCriterion("course_name between", value1, value2, "courseName");
            return (Criteria) this;
        }

        public Criteria andCourseNameNotBetween(String value1, String value2) {
            addCriterion("course_name not between", value1, value2, "courseName");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesIsNull() {
            addCriterion("number_courses_stages is null");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesIsNotNull() {
            addCriterion("number_courses_stages is not null");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesEqualTo(String value) {
            addCriterion("number_courses_stages =", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesNotEqualTo(String value) {
            addCriterion("number_courses_stages <>", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesGreaterThan(String value) {
            addCriterion("number_courses_stages >", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesGreaterThanOrEqualTo(String value) {
            addCriterion("number_courses_stages >=", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesLessThan(String value) {
            addCriterion("number_courses_stages <", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesLessThanOrEqualTo(String value) {
            addCriterion("number_courses_stages <=", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesLike(String value) {
            addCriterion("number_courses_stages like", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesNotLike(String value) {
            addCriterion("number_courses_stages not like", value, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesIn(List<String> values) {
            addCriterion("number_courses_stages in", values, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesNotIn(List<String> values) {
            addCriterion("number_courses_stages not in", values, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesBetween(String value1, String value2) {
            addCriterion("number_courses_stages between", value1, value2, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNumberCoursesStagesNotBetween(String value1, String value2) {
            addCriterion("number_courses_stages not between", value1, value2, "numberCoursesStages");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsIsNull() {
            addCriterion("name_participants is null");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsIsNotNull() {
            addCriterion("name_participants is not null");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsEqualTo(String value) {
            addCriterion("name_participants =", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsNotEqualTo(String value) {
            addCriterion("name_participants <>", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsGreaterThan(String value) {
            addCriterion("name_participants >", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsGreaterThanOrEqualTo(String value) {
            addCriterion("name_participants >=", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsLessThan(String value) {
            addCriterion("name_participants <", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsLessThanOrEqualTo(String value) {
            addCriterion("name_participants <=", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsLike(String value) {
            addCriterion("name_participants like", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsNotLike(String value) {
            addCriterion("name_participants not like", value, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsIn(List<String> values) {
            addCriterion("name_participants in", values, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsNotIn(List<String> values) {
            addCriterion("name_participants not in", values, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsBetween(String value1, String value2) {
            addCriterion("name_participants between", value1, value2, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andNameParticipantsNotBetween(String value1, String value2) {
            addCriterion("name_participants not between", value1, value2, "nameParticipants");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordIsNull() {
            addCriterion("offline_certificate_issuance_record is null");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordIsNotNull() {
            addCriterion("offline_certificate_issuance_record is not null");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordEqualTo(String value) {
            addCriterion("offline_certificate_issuance_record =", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordNotEqualTo(String value) {
            addCriterion("offline_certificate_issuance_record <>", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordGreaterThan(String value) {
            addCriterion("offline_certificate_issuance_record >", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordGreaterThanOrEqualTo(String value) {
            addCriterion("offline_certificate_issuance_record >=", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordLessThan(String value) {
            addCriterion("offline_certificate_issuance_record <", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordLessThanOrEqualTo(String value) {
            addCriterion("offline_certificate_issuance_record <=", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordLike(String value) {
            addCriterion("offline_certificate_issuance_record like", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordNotLike(String value) {
            addCriterion("offline_certificate_issuance_record not like", value, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordIn(List<String> values) {
            addCriterion("offline_certificate_issuance_record in", values, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordNotIn(List<String> values) {
            addCriterion("offline_certificate_issuance_record not in", values, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordBetween(String value1, String value2) {
            addCriterion("offline_certificate_issuance_record between", value1, value2, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOfflineCertificateIssuanceRecordNotBetween(String value1, String value2) {
            addCriterion("offline_certificate_issuance_record not between", value1, value2, "offlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNameIsNull() {
            addCriterion("certificate_name is null");
            return (Criteria) this;
        }

        public Criteria andCertificateNameIsNotNull() {
            addCriterion("certificate_name is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateNameEqualTo(String value) {
            addCriterion("certificate_name =", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameNotEqualTo(String value) {
            addCriterion("certificate_name <>", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameGreaterThan(String value) {
            addCriterion("certificate_name >", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameGreaterThanOrEqualTo(String value) {
            addCriterion("certificate_name >=", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameLessThan(String value) {
            addCriterion("certificate_name <", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameLessThanOrEqualTo(String value) {
            addCriterion("certificate_name <=", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameLike(String value) {
            addCriterion("certificate_name like", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameNotLike(String value) {
            addCriterion("certificate_name not like", value, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameIn(List<String> values) {
            addCriterion("certificate_name in", values, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameNotIn(List<String> values) {
            addCriterion("certificate_name not in", values, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameBetween(String value1, String value2) {
            addCriterion("certificate_name between", value1, value2, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNameNotBetween(String value1, String value2) {
            addCriterion("certificate_name not between", value1, value2, "certificateName");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordIsNull() {
            addCriterion("certificate_number_record is null");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordIsNotNull() {
            addCriterion("certificate_number_record is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordEqualTo(String value) {
            addCriterion("certificate_number_record =", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordNotEqualTo(String value) {
            addCriterion("certificate_number_record <>", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordGreaterThan(String value) {
            addCriterion("certificate_number_record >", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordGreaterThanOrEqualTo(String value) {
            addCriterion("certificate_number_record >=", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordLessThan(String value) {
            addCriterion("certificate_number_record <", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordLessThanOrEqualTo(String value) {
            addCriterion("certificate_number_record <=", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordLike(String value) {
            addCriterion("certificate_number_record like", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordNotLike(String value) {
            addCriterion("certificate_number_record not like", value, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordIn(List<String> values) {
            addCriterion("certificate_number_record in", values, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordNotIn(List<String> values) {
            addCriterion("certificate_number_record not in", values, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordBetween(String value1, String value2) {
            addCriterion("certificate_number_record between", value1, value2, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andCertificateNumberRecordNotBetween(String value1, String value2) {
            addCriterion("certificate_number_record not between", value1, value2, "certificateNumberRecord");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andDateIssueIsNull() {
            addCriterion("date_issue is null");
            return (Criteria) this;
        }

        public Criteria andDateIssueIsNotNull() {
            addCriterion("date_issue is not null");
            return (Criteria) this;
        }

        public Criteria andDateIssueEqualTo(String value) {
            addCriterion("date_issue =", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueNotEqualTo(String value) {
            addCriterion("date_issue <>", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueGreaterThan(String value) {
            addCriterion("date_issue >", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueGreaterThanOrEqualTo(String value) {
            addCriterion("date_issue >=", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueLessThan(String value) {
            addCriterion("date_issue <", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueLessThanOrEqualTo(String value) {
            addCriterion("date_issue <=", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueLike(String value) {
            addCriterion("date_issue like", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueNotLike(String value) {
            addCriterion("date_issue not like", value, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueIn(List<String> values) {
            addCriterion("date_issue in", values, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueNotIn(List<String> values) {
            addCriterion("date_issue not in", values, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueBetween(String value1, String value2) {
            addCriterion("date_issue between", value1, value2, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andDateIssueNotBetween(String value1, String value2) {
            addCriterion("date_issue not between", value1, value2, "dateIssue");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordIsNull() {
            addCriterion("online_certificate_issuance_record is null");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordIsNotNull() {
            addCriterion("online_certificate_issuance_record is not null");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordEqualTo(String value) {
            addCriterion("online_certificate_issuance_record =", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordNotEqualTo(String value) {
            addCriterion("online_certificate_issuance_record <>", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordGreaterThan(String value) {
            addCriterion("online_certificate_issuance_record >", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordGreaterThanOrEqualTo(String value) {
            addCriterion("online_certificate_issuance_record >=", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordLessThan(String value) {
            addCriterion("online_certificate_issuance_record <", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordLessThanOrEqualTo(String value) {
            addCriterion("online_certificate_issuance_record <=", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordLike(String value) {
            addCriterion("online_certificate_issuance_record like", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordNotLike(String value) {
            addCriterion("online_certificate_issuance_record not like", value, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordIn(List<String> values) {
            addCriterion("online_certificate_issuance_record in", values, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordNotIn(List<String> values) {
            addCriterion("online_certificate_issuance_record not in", values, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordBetween(String value1, String value2) {
            addCriterion("online_certificate_issuance_record between", value1, value2, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOnlineCertificateIssuanceRecordNotBetween(String value1, String value2) {
            addCriterion("online_certificate_issuance_record not between", value1, value2, "onlineCertificateIssuanceRecord");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNull() {
            addCriterion("order_number is null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNotNull() {
            addCriterion("order_number is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberEqualTo(String value) {
            addCriterion("order_number =", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotEqualTo(String value) {
            addCriterion("order_number <>", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThan(String value) {
            addCriterion("order_number >", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThanOrEqualTo(String value) {
            addCriterion("order_number >=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThan(String value) {
            addCriterion("order_number <", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThanOrEqualTo(String value) {
            addCriterion("order_number <=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLike(String value) {
            addCriterion("order_number like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotLike(String value) {
            addCriterion("order_number not like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIn(List<String> values) {
            addCriterion("order_number in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotIn(List<String> values) {
            addCriterion("order_number not in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberBetween(String value1, String value2) {
            addCriterion("order_number between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotBetween(String value1, String value2) {
            addCriterion("order_number not between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNull() {
            addCriterion("contract_number is null");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNotNull() {
            addCriterion("contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andContractNumberEqualTo(String value) {
            addCriterion("contract_number =", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotEqualTo(String value) {
            addCriterion("contract_number <>", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThan(String value) {
            addCriterion("contract_number >", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("contract_number >=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThan(String value) {
            addCriterion("contract_number <", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThanOrEqualTo(String value) {
            addCriterion("contract_number <=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLike(String value) {
            addCriterion("contract_number like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotLike(String value) {
            addCriterion("contract_number not like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIn(List<String> values) {
            addCriterion("contract_number in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotIn(List<String> values) {
            addCriterion("contract_number not in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberBetween(String value1, String value2) {
            addCriterion("contract_number between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotBetween(String value1, String value2) {
            addCriterion("contract_number not between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardIsNull() {
            addCriterion("membership_card is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardIsNotNull() {
            addCriterion("membership_card is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardEqualTo(String value) {
            addCriterion("membership_card =", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNotEqualTo(String value) {
            addCriterion("membership_card <>", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardGreaterThan(String value) {
            addCriterion("membership_card >", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card >=", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLessThan(String value) {
            addCriterion("membership_card <", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLessThanOrEqualTo(String value) {
            addCriterion("membership_card <=", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLike(String value) {
            addCriterion("membership_card like", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNotLike(String value) {
            addCriterion("membership_card not like", value, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardIn(List<String> values) {
            addCriterion("membership_card in", values, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNotIn(List<String> values) {
            addCriterion("membership_card not in", values, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardBetween(String value1, String value2) {
            addCriterion("membership_card between", value1, value2, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNotBetween(String value1, String value2) {
            addCriterion("membership_card not between", value1, value2, "membershipCard");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordIsNull() {
            addCriterion("exchange_record is null");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordIsNotNull() {
            addCriterion("exchange_record is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordEqualTo(String value) {
            addCriterion("exchange_record =", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordNotEqualTo(String value) {
            addCriterion("exchange_record <>", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordGreaterThan(String value) {
            addCriterion("exchange_record >", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordGreaterThanOrEqualTo(String value) {
            addCriterion("exchange_record >=", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordLessThan(String value) {
            addCriterion("exchange_record <", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordLessThanOrEqualTo(String value) {
            addCriterion("exchange_record <=", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordLike(String value) {
            addCriterion("exchange_record like", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordNotLike(String value) {
            addCriterion("exchange_record not like", value, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordIn(List<String> values) {
            addCriterion("exchange_record in", values, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordNotIn(List<String> values) {
            addCriterion("exchange_record not in", values, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordBetween(String value1, String value2) {
            addCriterion("exchange_record between", value1, value2, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andExchangeRecordNotBetween(String value1, String value2) {
            addCriterion("exchange_record not between", value1, value2, "exchangeRecord");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusIsNull() {
            addCriterion("membership_card_exchange_status is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusIsNotNull() {
            addCriterion("membership_card_exchange_status is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusEqualTo(String value) {
            addCriterion("membership_card_exchange_status =", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusNotEqualTo(String value) {
            addCriterion("membership_card_exchange_status <>", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusGreaterThan(String value) {
            addCriterion("membership_card_exchange_status >", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_exchange_status >=", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusLessThan(String value) {
            addCriterion("membership_card_exchange_status <", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusLessThanOrEqualTo(String value) {
            addCriterion("membership_card_exchange_status <=", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusLike(String value) {
            addCriterion("membership_card_exchange_status like", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusNotLike(String value) {
            addCriterion("membership_card_exchange_status not like", value, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusIn(List<String> values) {
            addCriterion("membership_card_exchange_status in", values, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusNotIn(List<String> values) {
            addCriterion("membership_card_exchange_status not in", values, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusBetween(String value1, String value2) {
            addCriterion("membership_card_exchange_status between", value1, value2, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andMembershipCardExchangeStatusNotBetween(String value1, String value2) {
            addCriterion("membership_card_exchange_status not between", value1, value2, "membershipCardExchangeStatus");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceIsNull() {
            addCriterion("on_site_attendance is null");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceIsNotNull() {
            addCriterion("on_site_attendance is not null");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceEqualTo(String value) {
            addCriterion("on_site_attendance =", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceNotEqualTo(String value) {
            addCriterion("on_site_attendance <>", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceGreaterThan(String value) {
            addCriterion("on_site_attendance >", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceGreaterThanOrEqualTo(String value) {
            addCriterion("on_site_attendance >=", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceLessThan(String value) {
            addCriterion("on_site_attendance <", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceLessThanOrEqualTo(String value) {
            addCriterion("on_site_attendance <=", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceLike(String value) {
            addCriterion("on_site_attendance like", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceNotLike(String value) {
            addCriterion("on_site_attendance not like", value, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceIn(List<String> values) {
            addCriterion("on_site_attendance in", values, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceNotIn(List<String> values) {
            addCriterion("on_site_attendance not in", values, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceBetween(String value1, String value2) {
            addCriterion("on_site_attendance between", value1, value2, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andOnSiteAttendanceNotBetween(String value1, String value2) {
            addCriterion("on_site_attendance not between", value1, value2, "onSiteAttendance");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeIsNull() {
            addCriterion("professional_exchange is null");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeIsNotNull() {
            addCriterion("professional_exchange is not null");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeEqualTo(String value) {
            addCriterion("professional_exchange =", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeNotEqualTo(String value) {
            addCriterion("professional_exchange <>", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeGreaterThan(String value) {
            addCriterion("professional_exchange >", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeGreaterThanOrEqualTo(String value) {
            addCriterion("professional_exchange >=", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeLessThan(String value) {
            addCriterion("professional_exchange <", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeLessThanOrEqualTo(String value) {
            addCriterion("professional_exchange <=", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeLike(String value) {
            addCriterion("professional_exchange like", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeNotLike(String value) {
            addCriterion("professional_exchange not like", value, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeIn(List<String> values) {
            addCriterion("professional_exchange in", values, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeNotIn(List<String> values) {
            addCriterion("professional_exchange not in", values, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeBetween(String value1, String value2) {
            addCriterion("professional_exchange between", value1, value2, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andProfessionalExchangeNotBetween(String value1, String value2) {
            addCriterion("professional_exchange not between", value1, value2, "professionalExchange");
            return (Criteria) this;
        }

        public Criteria andHighEndClassIsNull() {
            addCriterion("high_end_class is null");
            return (Criteria) this;
        }

        public Criteria andHighEndClassIsNotNull() {
            addCriterion("high_end_class is not null");
            return (Criteria) this;
        }

        public Criteria andHighEndClassEqualTo(String value) {
            addCriterion("high_end_class =", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassNotEqualTo(String value) {
            addCriterion("high_end_class <>", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassGreaterThan(String value) {
            addCriterion("high_end_class >", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassGreaterThanOrEqualTo(String value) {
            addCriterion("high_end_class >=", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassLessThan(String value) {
            addCriterion("high_end_class <", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassLessThanOrEqualTo(String value) {
            addCriterion("high_end_class <=", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassLike(String value) {
            addCriterion("high_end_class like", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassNotLike(String value) {
            addCriterion("high_end_class not like", value, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassIn(List<String> values) {
            addCriterion("high_end_class in", values, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassNotIn(List<String> values) {
            addCriterion("high_end_class not in", values, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassBetween(String value1, String value2) {
            addCriterion("high_end_class between", value1, value2, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andHighEndClassNotBetween(String value1, String value2) {
            addCriterion("high_end_class not between", value1, value2, "highEndClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassIsNull() {
            addCriterion("preparatory_class is null");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassIsNotNull() {
            addCriterion("preparatory_class is not null");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassEqualTo(String value) {
            addCriterion("preparatory_class =", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassNotEqualTo(String value) {
            addCriterion("preparatory_class <>", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassGreaterThan(String value) {
            addCriterion("preparatory_class >", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassGreaterThanOrEqualTo(String value) {
            addCriterion("preparatory_class >=", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassLessThan(String value) {
            addCriterion("preparatory_class <", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassLessThanOrEqualTo(String value) {
            addCriterion("preparatory_class <=", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassLike(String value) {
            addCriterion("preparatory_class like", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassNotLike(String value) {
            addCriterion("preparatory_class not like", value, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassIn(List<String> values) {
            addCriterion("preparatory_class in", values, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassNotIn(List<String> values) {
            addCriterion("preparatory_class not in", values, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassBetween(String value1, String value2) {
            addCriterion("preparatory_class between", value1, value2, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andPreparatoryClassNotBetween(String value1, String value2) {
            addCriterion("preparatory_class not between", value1, value2, "preparatoryClass");
            return (Criteria) this;
        }

        public Criteria andRecordNumberIsNull() {
            addCriterion("record_number is null");
            return (Criteria) this;
        }

        public Criteria andRecordNumberIsNotNull() {
            addCriterion("record_number is not null");
            return (Criteria) this;
        }

        public Criteria andRecordNumberEqualTo(String value) {
            addCriterion("record_number =", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberNotEqualTo(String value) {
            addCriterion("record_number <>", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberGreaterThan(String value) {
            addCriterion("record_number >", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberGreaterThanOrEqualTo(String value) {
            addCriterion("record_number >=", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberLessThan(String value) {
            addCriterion("record_number <", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberLessThanOrEqualTo(String value) {
            addCriterion("record_number <=", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberLike(String value) {
            addCriterion("record_number like", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberNotLike(String value) {
            addCriterion("record_number not like", value, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberIn(List<String> values) {
            addCriterion("record_number in", values, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberNotIn(List<String> values) {
            addCriterion("record_number not in", values, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberBetween(String value1, String value2) {
            addCriterion("record_number between", value1, value2, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andRecordNumberNotBetween(String value1, String value2) {
            addCriterion("record_number not between", value1, value2, "recordNumber");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionIsNull() {
            addCriterion("site_attendance_consumption is null");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionIsNotNull() {
            addCriterion("site_attendance_consumption is not null");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionEqualTo(String value) {
            addCriterion("site_attendance_consumption =", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionNotEqualTo(String value) {
            addCriterion("site_attendance_consumption <>", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionGreaterThan(String value) {
            addCriterion("site_attendance_consumption >", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionGreaterThanOrEqualTo(String value) {
            addCriterion("site_attendance_consumption >=", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionLessThan(String value) {
            addCriterion("site_attendance_consumption <", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionLessThanOrEqualTo(String value) {
            addCriterion("site_attendance_consumption <=", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionLike(String value) {
            addCriterion("site_attendance_consumption like", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionNotLike(String value) {
            addCriterion("site_attendance_consumption not like", value, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionIn(List<String> values) {
            addCriterion("site_attendance_consumption in", values, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionNotIn(List<String> values) {
            addCriterion("site_attendance_consumption not in", values, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionBetween(String value1, String value2) {
            addCriterion("site_attendance_consumption between", value1, value2, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andSiteAttendanceConsumptionNotBetween(String value1, String value2) {
            addCriterion("site_attendance_consumption not between", value1, value2, "siteAttendanceConsumption");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeIsNull() {
            addCriterion("industry_will_consume is null");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeIsNotNull() {
            addCriterion("industry_will_consume is not null");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeEqualTo(String value) {
            addCriterion("industry_will_consume =", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeNotEqualTo(String value) {
            addCriterion("industry_will_consume <>", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeGreaterThan(String value) {
            addCriterion("industry_will_consume >", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeGreaterThanOrEqualTo(String value) {
            addCriterion("industry_will_consume >=", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeLessThan(String value) {
            addCriterion("industry_will_consume <", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeLessThanOrEqualTo(String value) {
            addCriterion("industry_will_consume <=", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeLike(String value) {
            addCriterion("industry_will_consume like", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeNotLike(String value) {
            addCriterion("industry_will_consume not like", value, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeIn(List<String> values) {
            addCriterion("industry_will_consume in", values, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeNotIn(List<String> values) {
            addCriterion("industry_will_consume not in", values, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeBetween(String value1, String value2) {
            addCriterion("industry_will_consume between", value1, value2, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andIndustryWillConsumeNotBetween(String value1, String value2) {
            addCriterion("industry_will_consume not between", value1, value2, "industryWillConsume");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionIsNull() {
            addCriterion("high_shift_consumption is null");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionIsNotNull() {
            addCriterion("high_shift_consumption is not null");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionEqualTo(String value) {
            addCriterion("high_shift_consumption =", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionNotEqualTo(String value) {
            addCriterion("high_shift_consumption <>", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionGreaterThan(String value) {
            addCriterion("high_shift_consumption >", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionGreaterThanOrEqualTo(String value) {
            addCriterion("high_shift_consumption >=", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionLessThan(String value) {
            addCriterion("high_shift_consumption <", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionLessThanOrEqualTo(String value) {
            addCriterion("high_shift_consumption <=", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionLike(String value) {
            addCriterion("high_shift_consumption like", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionNotLike(String value) {
            addCriterion("high_shift_consumption not like", value, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionIn(List<String> values) {
            addCriterion("high_shift_consumption in", values, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionNotIn(List<String> values) {
            addCriterion("high_shift_consumption not in", values, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionBetween(String value1, String value2) {
            addCriterion("high_shift_consumption between", value1, value2, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andHighShiftConsumptionNotBetween(String value1, String value2) {
            addCriterion("high_shift_consumption not between", value1, value2, "highShiftConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionIsNull() {
            addCriterion("reserve_class_consumption is null");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionIsNotNull() {
            addCriterion("reserve_class_consumption is not null");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionEqualTo(String value) {
            addCriterion("reserve_class_consumption =", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionNotEqualTo(String value) {
            addCriterion("reserve_class_consumption <>", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionGreaterThan(String value) {
            addCriterion("reserve_class_consumption >", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionGreaterThanOrEqualTo(String value) {
            addCriterion("reserve_class_consumption >=", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionLessThan(String value) {
            addCriterion("reserve_class_consumption <", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionLessThanOrEqualTo(String value) {
            addCriterion("reserve_class_consumption <=", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionLike(String value) {
            addCriterion("reserve_class_consumption like", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionNotLike(String value) {
            addCriterion("reserve_class_consumption not like", value, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionIn(List<String> values) {
            addCriterion("reserve_class_consumption in", values, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionNotIn(List<String> values) {
            addCriterion("reserve_class_consumption not in", values, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionBetween(String value1, String value2) {
            addCriterion("reserve_class_consumption between", value1, value2, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andReserveClassConsumptionNotBetween(String value1, String value2) {
            addCriterion("reserve_class_consumption not between", value1, value2, "reserveClassConsumption");
            return (Criteria) this;
        }

        public Criteria andNewCardIsNull() {
            addCriterion("new_card is null");
            return (Criteria) this;
        }

        public Criteria andNewCardIsNotNull() {
            addCriterion("new_card is not null");
            return (Criteria) this;
        }

        public Criteria andNewCardEqualTo(String value) {
            addCriterion("new_card =", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardNotEqualTo(String value) {
            addCriterion("new_card <>", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardGreaterThan(String value) {
            addCriterion("new_card >", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardGreaterThanOrEqualTo(String value) {
            addCriterion("new_card >=", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardLessThan(String value) {
            addCriterion("new_card <", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardLessThanOrEqualTo(String value) {
            addCriterion("new_card <=", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardLike(String value) {
            addCriterion("new_card like", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardNotLike(String value) {
            addCriterion("new_card not like", value, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardIn(List<String> values) {
            addCriterion("new_card in", values, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardNotIn(List<String> values) {
            addCriterion("new_card not in", values, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardBetween(String value1, String value2) {
            addCriterion("new_card between", value1, value2, "newCard");
            return (Criteria) this;
        }

        public Criteria andNewCardNotBetween(String value1, String value2) {
            addCriterion("new_card not between", value1, value2, "newCard");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIsNull() {
            addCriterion("membership_card_level is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIsNotNull() {
            addCriterion("membership_card_level is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelEqualTo(String value) {
            addCriterion("membership_card_level =", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotEqualTo(String value) {
            addCriterion("membership_card_level <>", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelGreaterThan(String value) {
            addCriterion("membership_card_level >", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_level >=", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLessThan(String value) {
            addCriterion("membership_card_level <", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLessThanOrEqualTo(String value) {
            addCriterion("membership_card_level <=", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLike(String value) {
            addCriterion("membership_card_level like", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotLike(String value) {
            addCriterion("membership_card_level not like", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIn(List<String> values) {
            addCriterion("membership_card_level in", values, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotIn(List<String> values) {
            addCriterion("membership_card_level not in", values, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelBetween(String value1, String value2) {
            addCriterion("membership_card_level between", value1, value2, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotBetween(String value1, String value2) {
            addCriterion("membership_card_level not between", value1, value2, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeIsNull() {
            addCriterion("extended_expiration_time is null");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeIsNotNull() {
            addCriterion("extended_expiration_time is not null");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeEqualTo(String value) {
            addCriterion("extended_expiration_time =", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeNotEqualTo(String value) {
            addCriterion("extended_expiration_time <>", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeGreaterThan(String value) {
            addCriterion("extended_expiration_time >", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeGreaterThanOrEqualTo(String value) {
            addCriterion("extended_expiration_time >=", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeLessThan(String value) {
            addCriterion("extended_expiration_time <", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeLessThanOrEqualTo(String value) {
            addCriterion("extended_expiration_time <=", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeLike(String value) {
            addCriterion("extended_expiration_time like", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeNotLike(String value) {
            addCriterion("extended_expiration_time not like", value, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeIn(List<String> values) {
            addCriterion("extended_expiration_time in", values, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeNotIn(List<String> values) {
            addCriterion("extended_expiration_time not in", values, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeBetween(String value1, String value2) {
            addCriterion("extended_expiration_time between", value1, value2, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andExtendedExpirationTimeNotBetween(String value1, String value2) {
            addCriterion("extended_expiration_time not between", value1, value2, "extendedExpirationTime");
            return (Criteria) this;
        }

        public Criteria andIsItValidIsNull() {
            addCriterion("is_it_valid is null");
            return (Criteria) this;
        }

        public Criteria andIsItValidIsNotNull() {
            addCriterion("is_it_valid is not null");
            return (Criteria) this;
        }

        public Criteria andIsItValidEqualTo(String value) {
            addCriterion("is_it_valid =", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidNotEqualTo(String value) {
            addCriterion("is_it_valid <>", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidGreaterThan(String value) {
            addCriterion("is_it_valid >", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidGreaterThanOrEqualTo(String value) {
            addCriterion("is_it_valid >=", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidLessThan(String value) {
            addCriterion("is_it_valid <", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidLessThanOrEqualTo(String value) {
            addCriterion("is_it_valid <=", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidLike(String value) {
            addCriterion("is_it_valid like", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidNotLike(String value) {
            addCriterion("is_it_valid not like", value, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidIn(List<String> values) {
            addCriterion("is_it_valid in", values, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidNotIn(List<String> values) {
            addCriterion("is_it_valid not in", values, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidBetween(String value1, String value2) {
            addCriterion("is_it_valid between", value1, value2, "isItValid");
            return (Criteria) this;
        }

        public Criteria andIsItValidNotBetween(String value1, String value2) {
            addCriterion("is_it_valid not between", value1, value2, "isItValid");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthIsNull() {
            addCriterion("card_expires_twelve_month is null");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthIsNotNull() {
            addCriterion("card_expires_twelve_month is not null");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthEqualTo(String value) {
            addCriterion("card_expires_twelve_month =", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthNotEqualTo(String value) {
            addCriterion("card_expires_twelve_month <>", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthGreaterThan(String value) {
            addCriterion("card_expires_twelve_month >", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthGreaterThanOrEqualTo(String value) {
            addCriterion("card_expires_twelve_month >=", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthLessThan(String value) {
            addCriterion("card_expires_twelve_month <", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthLessThanOrEqualTo(String value) {
            addCriterion("card_expires_twelve_month <=", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthLike(String value) {
            addCriterion("card_expires_twelve_month like", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthNotLike(String value) {
            addCriterion("card_expires_twelve_month not like", value, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthIn(List<String> values) {
            addCriterion("card_expires_twelve_month in", values, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthNotIn(List<String> values) {
            addCriterion("card_expires_twelve_month not in", values, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthBetween(String value1, String value2) {
            addCriterion("card_expires_twelve_month between", value1, value2, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andCardExpiresTwelveMonthNotBetween(String value1, String value2) {
            addCriterion("card_expires_twelve_month not between", value1, value2, "cardExpiresTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthIsNull() {
            addCriterion("expiration_after_twelve_month is null");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthIsNotNull() {
            addCriterion("expiration_after_twelve_month is not null");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthEqualTo(String value) {
            addCriterion("expiration_after_twelve_month =", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthNotEqualTo(String value) {
            addCriterion("expiration_after_twelve_month <>", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthGreaterThan(String value) {
            addCriterion("expiration_after_twelve_month >", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthGreaterThanOrEqualTo(String value) {
            addCriterion("expiration_after_twelve_month >=", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthLessThan(String value) {
            addCriterion("expiration_after_twelve_month <", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthLessThanOrEqualTo(String value) {
            addCriterion("expiration_after_twelve_month <=", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthLike(String value) {
            addCriterion("expiration_after_twelve_month like", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthNotLike(String value) {
            addCriterion("expiration_after_twelve_month not like", value, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthIn(List<String> values) {
            addCriterion("expiration_after_twelve_month in", values, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthNotIn(List<String> values) {
            addCriterion("expiration_after_twelve_month not in", values, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthBetween(String value1, String value2) {
            addCriterion("expiration_after_twelve_month between", value1, value2, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andExpirationAfterTwelveMonthNotBetween(String value1, String value2) {
            addCriterion("expiration_after_twelve_month not between", value1, value2, "expirationAfterTwelveMonth");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesIsNull() {
            addCriterion("online_class_live_broadcast_times is null");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesIsNotNull() {
            addCriterion("online_class_live_broadcast_times is not null");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesEqualTo(String value) {
            addCriterion("online_class_live_broadcast_times =", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesNotEqualTo(String value) {
            addCriterion("online_class_live_broadcast_times <>", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesGreaterThan(String value) {
            addCriterion("online_class_live_broadcast_times >", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesGreaterThanOrEqualTo(String value) {
            addCriterion("online_class_live_broadcast_times >=", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesLessThan(String value) {
            addCriterion("online_class_live_broadcast_times <", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesLessThanOrEqualTo(String value) {
            addCriterion("online_class_live_broadcast_times <=", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesLike(String value) {
            addCriterion("online_class_live_broadcast_times like", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesNotLike(String value) {
            addCriterion("online_class_live_broadcast_times not like", value, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesIn(List<String> values) {
            addCriterion("online_class_live_broadcast_times in", values, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesNotIn(List<String> values) {
            addCriterion("online_class_live_broadcast_times not in", values, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesBetween(String value1, String value2) {
            addCriterion("online_class_live_broadcast_times between", value1, value2, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andOnlineClassLiveBroadcastTimesNotBetween(String value1, String value2) {
            addCriterion("online_class_live_broadcast_times not between", value1, value2, "onlineClassLiveBroadcastTimes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesIsNull() {
            addCriterion("network_minutes is null");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesIsNotNull() {
            addCriterion("network_minutes is not null");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesEqualTo(String value) {
            addCriterion("network_minutes =", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesNotEqualTo(String value) {
            addCriterion("network_minutes <>", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesGreaterThan(String value) {
            addCriterion("network_minutes >", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesGreaterThanOrEqualTo(String value) {
            addCriterion("network_minutes >=", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesLessThan(String value) {
            addCriterion("network_minutes <", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesLessThanOrEqualTo(String value) {
            addCriterion("network_minutes <=", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesLike(String value) {
            addCriterion("network_minutes like", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesNotLike(String value) {
            addCriterion("network_minutes not like", value, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesIn(List<String> values) {
            addCriterion("network_minutes in", values, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesNotIn(List<String> values) {
            addCriterion("network_minutes not in", values, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesBetween(String value1, String value2) {
            addCriterion("network_minutes between", value1, value2, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNetworkMinutesNotBetween(String value1, String value2) {
            addCriterion("network_minutes not between", value1, value2, "networkMinutes");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsIsNull() {
            addCriterion("number_sub_accounts is null");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsIsNotNull() {
            addCriterion("number_sub_accounts is not null");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsEqualTo(String value) {
            addCriterion("number_sub_accounts =", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsNotEqualTo(String value) {
            addCriterion("number_sub_accounts <>", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsGreaterThan(String value) {
            addCriterion("number_sub_accounts >", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsGreaterThanOrEqualTo(String value) {
            addCriterion("number_sub_accounts >=", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsLessThan(String value) {
            addCriterion("number_sub_accounts <", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsLessThanOrEqualTo(String value) {
            addCriterion("number_sub_accounts <=", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsLike(String value) {
            addCriterion("number_sub_accounts like", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsNotLike(String value) {
            addCriterion("number_sub_accounts not like", value, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsIn(List<String> values) {
            addCriterion("number_sub_accounts in", values, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsNotIn(List<String> values) {
            addCriterion("number_sub_accounts not in", values, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsBetween(String value1, String value2) {
            addCriterion("number_sub_accounts between", value1, value2, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andNumberSubAccountsNotBetween(String value1, String value2) {
            addCriterion("number_sub_accounts not between", value1, value2, "numberSubAccounts");
            return (Criteria) this;
        }

        public Criteria andProductQuantityIsNull() {
            addCriterion("product_quantity is null");
            return (Criteria) this;
        }

        public Criteria andProductQuantityIsNotNull() {
            addCriterion("product_quantity is not null");
            return (Criteria) this;
        }

        public Criteria andProductQuantityEqualTo(String value) {
            addCriterion("product_quantity =", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityNotEqualTo(String value) {
            addCriterion("product_quantity <>", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityGreaterThan(String value) {
            addCriterion("product_quantity >", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityGreaterThanOrEqualTo(String value) {
            addCriterion("product_quantity >=", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityLessThan(String value) {
            addCriterion("product_quantity <", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityLessThanOrEqualTo(String value) {
            addCriterion("product_quantity <=", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityLike(String value) {
            addCriterion("product_quantity like", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityNotLike(String value) {
            addCriterion("product_quantity not like", value, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityIn(List<String> values) {
            addCriterion("product_quantity in", values, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityNotIn(List<String> values) {
            addCriterion("product_quantity not in", values, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityBetween(String value1, String value2) {
            addCriterion("product_quantity between", value1, value2, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductQuantityNotBetween(String value1, String value2) {
            addCriterion("product_quantity not between", value1, value2, "productQuantity");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceIsNull() {
            addCriterion("product_unit_price is null");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceIsNotNull() {
            addCriterion("product_unit_price is not null");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceEqualTo(String value) {
            addCriterion("product_unit_price =", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceNotEqualTo(String value) {
            addCriterion("product_unit_price <>", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceGreaterThan(String value) {
            addCriterion("product_unit_price >", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceGreaterThanOrEqualTo(String value) {
            addCriterion("product_unit_price >=", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceLessThan(String value) {
            addCriterion("product_unit_price <", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceLessThanOrEqualTo(String value) {
            addCriterion("product_unit_price <=", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceLike(String value) {
            addCriterion("product_unit_price like", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceNotLike(String value) {
            addCriterion("product_unit_price not like", value, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceIn(List<String> values) {
            addCriterion("product_unit_price in", values, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceNotIn(List<String> values) {
            addCriterion("product_unit_price not in", values, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceBetween(String value1, String value2) {
            addCriterion("product_unit_price between", value1, value2, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andProductUnitPriceNotBetween(String value1, String value2) {
            addCriterion("product_unit_price not between", value1, value2, "productUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceIsNull() {
            addCriterion("total_product_price is null");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceIsNotNull() {
            addCriterion("total_product_price is not null");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceEqualTo(String value) {
            addCriterion("total_product_price =", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceNotEqualTo(String value) {
            addCriterion("total_product_price <>", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceGreaterThan(String value) {
            addCriterion("total_product_price >", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceGreaterThanOrEqualTo(String value) {
            addCriterion("total_product_price >=", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceLessThan(String value) {
            addCriterion("total_product_price <", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceLessThanOrEqualTo(String value) {
            addCriterion("total_product_price <=", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceLike(String value) {
            addCriterion("total_product_price like", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceNotLike(String value) {
            addCriterion("total_product_price not like", value, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceIn(List<String> values) {
            addCriterion("total_product_price in", values, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceNotIn(List<String> values) {
            addCriterion("total_product_price not in", values, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceBetween(String value1, String value2) {
            addCriterion("total_product_price between", value1, value2, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andTotalProductPriceNotBetween(String value1, String value2) {
            addCriterion("total_product_price not between", value1, value2, "totalProductPrice");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountIsNull() {
            addCriterion("preferential_amount is null");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountIsNotNull() {
            addCriterion("preferential_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountEqualTo(String value) {
            addCriterion("preferential_amount =", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountNotEqualTo(String value) {
            addCriterion("preferential_amount <>", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountGreaterThan(String value) {
            addCriterion("preferential_amount >", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountGreaterThanOrEqualTo(String value) {
            addCriterion("preferential_amount >=", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountLessThan(String value) {
            addCriterion("preferential_amount <", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountLessThanOrEqualTo(String value) {
            addCriterion("preferential_amount <=", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountLike(String value) {
            addCriterion("preferential_amount like", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountNotLike(String value) {
            addCriterion("preferential_amount not like", value, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountIn(List<String> values) {
            addCriterion("preferential_amount in", values, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountNotIn(List<String> values) {
            addCriterion("preferential_amount not in", values, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountBetween(String value1, String value2) {
            addCriterion("preferential_amount between", value1, value2, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andPreferentialAmountNotBetween(String value1, String value2) {
            addCriterion("preferential_amount not between", value1, value2, "preferentialAmount");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceIsNull() {
            addCriterion("actual_transaction_price is null");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceIsNotNull() {
            addCriterion("actual_transaction_price is not null");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceEqualTo(String value) {
            addCriterion("actual_transaction_price =", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotEqualTo(String value) {
            addCriterion("actual_transaction_price <>", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceGreaterThan(String value) {
            addCriterion("actual_transaction_price >", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceGreaterThanOrEqualTo(String value) {
            addCriterion("actual_transaction_price >=", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceLessThan(String value) {
            addCriterion("actual_transaction_price <", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceLessThanOrEqualTo(String value) {
            addCriterion("actual_transaction_price <=", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceLike(String value) {
            addCriterion("actual_transaction_price like", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotLike(String value) {
            addCriterion("actual_transaction_price not like", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceIn(List<String> values) {
            addCriterion("actual_transaction_price in", values, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotIn(List<String> values) {
            addCriterion("actual_transaction_price not in", values, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceBetween(String value1, String value2) {
            addCriterion("actual_transaction_price between", value1, value2, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotBetween(String value1, String value2) {
            addCriterion("actual_transaction_price not between", value1, value2, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIsNull() {
            addCriterion("membership_card_type is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIsNotNull() {
            addCriterion("membership_card_type is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeEqualTo(String value) {
            addCriterion("membership_card_type =", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotEqualTo(String value) {
            addCriterion("membership_card_type <>", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeGreaterThan(String value) {
            addCriterion("membership_card_type >", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_type >=", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLessThan(String value) {
            addCriterion("membership_card_type <", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLessThanOrEqualTo(String value) {
            addCriterion("membership_card_type <=", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLike(String value) {
            addCriterion("membership_card_type like", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotLike(String value) {
            addCriterion("membership_card_type not like", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIn(List<String> values) {
            addCriterion("membership_card_type in", values, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotIn(List<String> values) {
            addCriterion("membership_card_type not in", values, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeBetween(String value1, String value2) {
            addCriterion("membership_card_type between", value1, value2, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotBetween(String value1, String value2) {
            addCriterion("membership_card_type not between", value1, value2, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordIsNull() {
            addCriterion("electronic_card_password is null");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordIsNotNull() {
            addCriterion("electronic_card_password is not null");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordEqualTo(String value) {
            addCriterion("electronic_card_password =", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordNotEqualTo(String value) {
            addCriterion("electronic_card_password <>", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordGreaterThan(String value) {
            addCriterion("electronic_card_password >", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("electronic_card_password >=", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordLessThan(String value) {
            addCriterion("electronic_card_password <", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordLessThanOrEqualTo(String value) {
            addCriterion("electronic_card_password <=", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordLike(String value) {
            addCriterion("electronic_card_password like", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordNotLike(String value) {
            addCriterion("electronic_card_password not like", value, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordIn(List<String> values) {
            addCriterion("electronic_card_password in", values, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordNotIn(List<String> values) {
            addCriterion("electronic_card_password not in", values, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordBetween(String value1, String value2) {
            addCriterion("electronic_card_password between", value1, value2, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andElectronicCardPasswordNotBetween(String value1, String value2) {
            addCriterion("electronic_card_password not between", value1, value2, "electronicCardPassword");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateIsNull() {
            addCriterion("effective_start_date is null");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateIsNotNull() {
            addCriterion("effective_start_date is not null");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateEqualTo(String value) {
            addCriterion("effective_start_date =", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateNotEqualTo(String value) {
            addCriterion("effective_start_date <>", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateGreaterThan(String value) {
            addCriterion("effective_start_date >", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateGreaterThanOrEqualTo(String value) {
            addCriterion("effective_start_date >=", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateLessThan(String value) {
            addCriterion("effective_start_date <", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateLessThanOrEqualTo(String value) {
            addCriterion("effective_start_date <=", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateLike(String value) {
            addCriterion("effective_start_date like", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateNotLike(String value) {
            addCriterion("effective_start_date not like", value, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateIn(List<String> values) {
            addCriterion("effective_start_date in", values, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateNotIn(List<String> values) {
            addCriterion("effective_start_date not in", values, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateBetween(String value1, String value2) {
            addCriterion("effective_start_date between", value1, value2, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andEffectiveStartDateNotBetween(String value1, String value2) {
            addCriterion("effective_start_date not between", value1, value2, "effectiveStartDate");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidIsNull() {
            addCriterion("`is_the_membership_card valid` is null");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidIsNotNull() {
            addCriterion("`is_the_membership_card valid` is not null");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidEqualTo(String value) {
            addCriterion("`is_the_membership_card valid` =", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidNotEqualTo(String value) {
            addCriterion("`is_the_membership_card valid` <>", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidGreaterThan(String value) {
            addCriterion("`is_the_membership_card valid` >", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidGreaterThanOrEqualTo(String value) {
            addCriterion("`is_the_membership_card valid` >=", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidLessThan(String value) {
            addCriterion("`is_the_membership_card valid` <", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidLessThanOrEqualTo(String value) {
            addCriterion("`is_the_membership_card valid` <=", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidLike(String value) {
            addCriterion("`is_the_membership_card valid` like", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidNotLike(String value) {
            addCriterion("`is_the_membership_card valid` not like", value, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidIn(List<String> values) {
            addCriterion("`is_the_membership_card valid` in", values, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidNotIn(List<String> values) {
            addCriterion("`is_the_membership_card valid` not in", values, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidBetween(String value1, String value2) {
            addCriterion("`is_the_membership_card valid` between", value1, value2, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andIsTheMembershipCardValidNotBetween(String value1, String value2) {
            addCriterion("`is_the_membership_card valid` not between", value1, value2, "isTheMembershipCardValid");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodIsNull() {
            addCriterion("expired_membership_period is null");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodIsNotNull() {
            addCriterion("expired_membership_period is not null");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodEqualTo(String value) {
            addCriterion("expired_membership_period =", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodNotEqualTo(String value) {
            addCriterion("expired_membership_period <>", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodGreaterThan(String value) {
            addCriterion("expired_membership_period >", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodGreaterThanOrEqualTo(String value) {
            addCriterion("expired_membership_period >=", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodLessThan(String value) {
            addCriterion("expired_membership_period <", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodLessThanOrEqualTo(String value) {
            addCriterion("expired_membership_period <=", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodLike(String value) {
            addCriterion("expired_membership_period like", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodNotLike(String value) {
            addCriterion("expired_membership_period not like", value, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodIn(List<String> values) {
            addCriterion("expired_membership_period in", values, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodNotIn(List<String> values) {
            addCriterion("expired_membership_period not in", values, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodBetween(String value1, String value2) {
            addCriterion("expired_membership_period between", value1, value2, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andExpiredMembershipPeriodNotBetween(String value1, String value2) {
            addCriterion("expired_membership_period not between", value1, value2, "expiredMembershipPeriod");
            return (Criteria) this;
        }

        public Criteria andBranchNoIsNull() {
            addCriterion("branch_no is null");
            return (Criteria) this;
        }

        public Criteria andBranchNoIsNotNull() {
            addCriterion("branch_no is not null");
            return (Criteria) this;
        }

        public Criteria andBranchNoEqualTo(String value) {
            addCriterion("branch_no =", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoNotEqualTo(String value) {
            addCriterion("branch_no <>", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoGreaterThan(String value) {
            addCriterion("branch_no >", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoGreaterThanOrEqualTo(String value) {
            addCriterion("branch_no >=", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoLessThan(String value) {
            addCriterion("branch_no <", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoLessThanOrEqualTo(String value) {
            addCriterion("branch_no <=", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoLike(String value) {
            addCriterion("branch_no like", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoNotLike(String value) {
            addCriterion("branch_no not like", value, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoIn(List<String> values) {
            addCriterion("branch_no in", values, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoNotIn(List<String> values) {
            addCriterion("branch_no not in", values, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoBetween(String value1, String value2) {
            addCriterion("branch_no between", value1, value2, "branchNo");
            return (Criteria) this;
        }

        public Criteria andBranchNoNotBetween(String value1, String value2) {
            addCriterion("branch_no not between", value1, value2, "branchNo");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateIsNull() {
            addCriterion("latest_follow_up_date is null");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateIsNotNull() {
            addCriterion("latest_follow_up_date is not null");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateEqualTo(String value) {
            addCriterion("latest_follow_up_date =", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateNotEqualTo(String value) {
            addCriterion("latest_follow_up_date <>", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateGreaterThan(String value) {
            addCriterion("latest_follow_up_date >", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateGreaterThanOrEqualTo(String value) {
            addCriterion("latest_follow_up_date >=", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateLessThan(String value) {
            addCriterion("latest_follow_up_date <", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateLessThanOrEqualTo(String value) {
            addCriterion("latest_follow_up_date <=", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateLike(String value) {
            addCriterion("latest_follow_up_date like", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateNotLike(String value) {
            addCriterion("latest_follow_up_date not like", value, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateIn(List<String> values) {
            addCriterion("latest_follow_up_date in", values, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateNotIn(List<String> values) {
            addCriterion("latest_follow_up_date not in", values, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateBetween(String value1, String value2) {
            addCriterion("latest_follow_up_date between", value1, value2, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andLatestFollowUpDateNotBetween(String value1, String value2) {
            addCriterion("latest_follow_up_date not between", value1, value2, "latestFollowUpDate");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNull() {
            addCriterion("original_customer_id is null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNotNull() {
            addCriterion("original_customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdEqualTo(String value) {
            addCriterion("original_customer_id =", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotEqualTo(String value) {
            addCriterion("original_customer_id <>", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThan(String value) {
            addCriterion("original_customer_id >", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("original_customer_id >=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThan(String value) {
            addCriterion("original_customer_id <", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("original_customer_id <=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLike(String value) {
            addCriterion("original_customer_id like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotLike(String value) {
            addCriterion("original_customer_id not like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIn(List<String> values) {
            addCriterion("original_customer_id in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotIn(List<String> values) {
            addCriterion("original_customer_id not in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdBetween(String value1, String value2) {
            addCriterion("original_customer_id between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotBetween(String value1, String value2) {
            addCriterion("original_customer_id not between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeIsNull() {
            addCriterion("expiration_time is null");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeIsNotNull() {
            addCriterion("expiration_time is not null");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeEqualTo(String value) {
            addCriterion("expiration_time =", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeNotEqualTo(String value) {
            addCriterion("expiration_time <>", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeGreaterThan(String value) {
            addCriterion("expiration_time >", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeGreaterThanOrEqualTo(String value) {
            addCriterion("expiration_time >=", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeLessThan(String value) {
            addCriterion("expiration_time <", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeLessThanOrEqualTo(String value) {
            addCriterion("expiration_time <=", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeLike(String value) {
            addCriterion("expiration_time like", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeNotLike(String value) {
            addCriterion("expiration_time not like", value, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeIn(List<String> values) {
            addCriterion("expiration_time in", values, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeNotIn(List<String> values) {
            addCriterion("expiration_time not in", values, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeBetween(String value1, String value2) {
            addCriterion("expiration_time between", value1, value2, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andExpirationTimeNotBetween(String value1, String value2) {
            addCriterion("expiration_time not between", value1, value2, "expirationTime");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationIsNull() {
            addCriterion("member_classification is null");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationIsNotNull() {
            addCriterion("member_classification is not null");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationEqualTo(String value) {
            addCriterion("member_classification =", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationNotEqualTo(String value) {
            addCriterion("member_classification <>", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationGreaterThan(String value) {
            addCriterion("member_classification >", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationGreaterThanOrEqualTo(String value) {
            addCriterion("member_classification >=", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationLessThan(String value) {
            addCriterion("member_classification <", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationLessThanOrEqualTo(String value) {
            addCriterion("member_classification <=", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationLike(String value) {
            addCriterion("member_classification like", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationNotLike(String value) {
            addCriterion("member_classification not like", value, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationIn(List<String> values) {
            addCriterion("member_classification in", values, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationNotIn(List<String> values) {
            addCriterion("member_classification not in", values, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationBetween(String value1, String value2) {
            addCriterion("member_classification between", value1, value2, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andMemberClassificationNotBetween(String value1, String value2) {
            addCriterion("member_classification not between", value1, value2, "memberClassification");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmIsNull() {
            addCriterion("card_update_tm is null");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmIsNotNull() {
            addCriterion("card_update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmEqualTo(String value) {
            addCriterion("card_update_tm =", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmNotEqualTo(String value) {
            addCriterion("card_update_tm <>", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmGreaterThan(String value) {
            addCriterion("card_update_tm >", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmGreaterThanOrEqualTo(String value) {
            addCriterion("card_update_tm >=", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmLessThan(String value) {
            addCriterion("card_update_tm <", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmLessThanOrEqualTo(String value) {
            addCriterion("card_update_tm <=", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmLike(String value) {
            addCriterion("card_update_tm like", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmNotLike(String value) {
            addCriterion("card_update_tm not like", value, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmIn(List<String> values) {
            addCriterion("card_update_tm in", values, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmNotIn(List<String> values) {
            addCriterion("card_update_tm not in", values, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmBetween(String value1, String value2) {
            addCriterion("card_update_tm between", value1, value2, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCardUpdateTmNotBetween(String value1, String value2) {
            addCriterion("card_update_tm not between", value1, value2, "cardUpdateTm");
            return (Criteria) this;
        }

        public Criteria andCreatorIsNull() {
            addCriterion("creator is null");
            return (Criteria) this;
        }

        public Criteria andCreatorIsNotNull() {
            addCriterion("creator is not null");
            return (Criteria) this;
        }

        public Criteria andCreatorEqualTo(String value) {
            addCriterion("creator =", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotEqualTo(String value) {
            addCriterion("creator <>", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorGreaterThan(String value) {
            addCriterion("creator >", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorGreaterThanOrEqualTo(String value) {
            addCriterion("creator >=", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLessThan(String value) {
            addCriterion("creator <", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLessThanOrEqualTo(String value) {
            addCriterion("creator <=", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLike(String value) {
            addCriterion("creator like", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotLike(String value) {
            addCriterion("creator not like", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorIn(List<String> values) {
            addCriterion("creator in", values, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotIn(List<String> values) {
            addCriterion("creator not in", values, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorBetween(String value1, String value2) {
            addCriterion("creator between", value1, value2, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotBetween(String value1, String value2) {
            addCriterion("creator not between", value1, value2, "creator");
            return (Criteria) this;
        }

        public Criteria andModifiedByIsNull() {
            addCriterion("modified_by is null");
            return (Criteria) this;
        }

        public Criteria andModifiedByIsNotNull() {
            addCriterion("modified_by is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedByEqualTo(String value) {
            addCriterion("modified_by =", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByNotEqualTo(String value) {
            addCriterion("modified_by <>", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByGreaterThan(String value) {
            addCriterion("modified_by >", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByGreaterThanOrEqualTo(String value) {
            addCriterion("modified_by >=", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByLessThan(String value) {
            addCriterion("modified_by <", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByLessThanOrEqualTo(String value) {
            addCriterion("modified_by <=", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByLike(String value) {
            addCriterion("modified_by like", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByNotLike(String value) {
            addCriterion("modified_by not like", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByIn(List<String> values) {
            addCriterion("modified_by in", values, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByNotIn(List<String> values) {
            addCriterion("modified_by not in", values, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByBetween(String value1, String value2) {
            addCriterion("modified_by between", value1, value2, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByNotBetween(String value1, String value2) {
            addCriterion("modified_by not between", value1, value2, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andAllIsNull() {
            addCriterion("all is null");
            return (Criteria) this;
        }

        public Criteria andAllIsNotNull() {
            addCriterion("all is not null");
            return (Criteria) this;
        }

        public Criteria andAllEqualTo(String value) {
            addCriterion("all =", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllNotEqualTo(String value) {
            addCriterion("all <>", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllGreaterThan(String value) {
            addCriterion("all >", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllGreaterThanOrEqualTo(String value) {
            addCriterion("all >=", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllLessThan(String value) {
            addCriterion("all <", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllLessThanOrEqualTo(String value) {
            addCriterion("all <=", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllLike(String value) {
            addCriterion("all like", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllNotLike(String value) {
            addCriterion("all not like", value, "all");
            return (Criteria) this;
        }

        public Criteria andAllIn(List<String> values) {
            addCriterion("all in", values, "all");
            return (Criteria) this;
        }

        public Criteria andAllNotIn(List<String> values) {
            addCriterion("all not in", values, "all");
            return (Criteria) this;
        }

        public Criteria andAllBetween(String value1, String value2) {
            addCriterion("all between", value1, value2, "all");
            return (Criteria) this;
        }

        public Criteria andAllNotBetween(String value1, String value2) {
            addCriterion("all not between", value1, value2, "all");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNull() {
            addCriterion("create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNotNull() {
            addCriterion("create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTmEqualTo(Date value) {
            addCriterion("create_tm =", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotEqualTo(Date value) {
            addCriterion("create_tm <>", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThan(Date value) {
            addCriterion("create_tm >", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("create_tm >=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThan(Date value) {
            addCriterion("create_tm <", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThanOrEqualTo(Date value) {
            addCriterion("create_tm <=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmIn(List<Date> values) {
            addCriterion("create_tm in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotIn(List<Date> values) {
            addCriterion("create_tm not in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmBetween(Date value1, Date value2) {
            addCriterion("create_tm between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotBetween(Date value1, Date value2) {
            addCriterion("create_tm not between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNull() {
            addCriterion("update_people_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNotNull() {
            addCriterion("update_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdEqualTo(String value) {
            addCriterion("update_people_id =", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotEqualTo(String value) {
            addCriterion("update_people_id <>", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThan(String value) {
            addCriterion("update_people_id >", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_people_id >=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThan(String value) {
            addCriterion("update_people_id <", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("update_people_id <=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLike(String value) {
            addCriterion("update_people_id like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotLike(String value) {
            addCriterion("update_people_id not like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIn(List<String> values) {
            addCriterion("update_people_id in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotIn(List<String> values) {
            addCriterion("update_people_id not in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdBetween(String value1, String value2) {
            addCriterion("update_people_id between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("update_people_id not between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNull() {
            addCriterion("update_tm is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNotNull() {
            addCriterion("update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmEqualTo(Date value) {
            addCriterion("update_tm =", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotEqualTo(Date value) {
            addCriterion("update_tm <>", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThan(Date value) {
            addCriterion("update_tm >", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("update_tm >=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThan(Date value) {
            addCriterion("update_tm <", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThanOrEqualTo(Date value) {
            addCriterion("update_tm <=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIn(List<Date> values) {
            addCriterion("update_tm in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotIn(List<Date> values) {
            addCriterion("update_tm not in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmBetween(Date value1, Date value2) {
            addCriterion("update_tm between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotBetween(Date value1, Date value2) {
            addCriterion("update_tm not between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNull() {
            addCriterion("delete_status is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNotNull() {
            addCriterion("delete_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusEqualTo(Short value) {
            addCriterion("delete_status =", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotEqualTo(Short value) {
            addCriterion("delete_status <>", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThan(Short value) {
            addCriterion("delete_status >", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("delete_status >=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThan(Short value) {
            addCriterion("delete_status <", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThanOrEqualTo(Short value) {
            addCriterion("delete_status <=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIn(List<Short> values) {
            addCriterion("delete_status in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotIn(List<Short> values) {
            addCriterion("delete_status not in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusBetween(Short value1, Short value2) {
            addCriterion("delete_status between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotBetween(Short value1, Short value2) {
            addCriterion("delete_status not between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}